package cn.edu.lingnan.mapper;

import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface StudentMapper {
    // 按性别统计
    Integer countBySex(@Param("studentIds") List<Integer> studentIds, @Param("sex") Integer sex);

    // 分组统计应该返回 List
    List<Map<String, Object>> countByProvince(@Param("studentIds") List<Integer> studentIds);
    List<Map<String, Object>> countByCity(@Param("studentIds") List<Integer> studentIds);
    List<Map<String, Object>> countByBirthYear(@Param("studentIds") List<Integer> studentIds);
    List<Map<String, Object>> countByEthnicity(@Param("studentIds") List<Integer> studentIds);
    List<Map<String, Object>> countByPoliticalStatus(@Param("studentIds") List<Integer> studentIds);


}